<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BundooraLetters" targetNamespace="http://tempuri.org/BundooraLetters.xsd" xmlns:mstns="http://tempuri.org/BundooraLetters.xsd" xmlns="http://tempuri.org/BundooraLetters.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="PlacementManager" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PlacementManager (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.PlacementManager.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PlacementManager (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Venue.VenueName, Address.Address1, Address.Address2, Address.Street, Address.City, Address.PostCode, Address.StateId, Address.CountryId, 
                      Geo_AdministrativeDivision.DivisionName, Geo_Country.CountryName, Contact.Title, Contact.FirstName, Contact.LastName, Contact.JobTitle, 
                      Unit.UnitCode, Unit.UnitName, Unit.UnitDescription, Unit.YearLevel, PlacementType.PlacementTypeName, PlacementType.Year, 
                      PlacementType.SemesterId, PlacementType.RequiredHours, PlacementType.DateStart, PlacementType.DateEnd
FROM         Geo_Country INNER JOIN
                      Venue INNER JOIN
                      LinkVenueAddress ON Venue.VenueId = LinkVenueAddress.VenueId INNER JOIN
                      Address ON LinkVenueAddress.AddressId = Address.AddressId INNER JOIN
                      Geo_AdministrativeDivision ON Address.StateId = Geo_AdministrativeDivision.AdministrativeDivisionID ON 
                      Geo_Country.CountryID = Address.CountryId INNER JOIN
                      LinkVenueContact ON Venue.VenueId = LinkVenueContact.VenueId INNER JOIN
                      Contact ON LinkVenueContact.ContactId = Contact.ContactId INNER JOIN
                      LinkVenueUnit ON Venue.VenueId = LinkVenueUnit.VenueId INNER JOIN
                      Unit ON LinkVenueUnit.UnitId = Unit.UnitId INNER JOIN
                      PlacementType ON Unit.UnitId = PlacementType.UnitId</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VenueName" DataSetColumn="VenueName" />
              <Mapping SourceColumn="UnitCode" DataSetColumn="UnitCode" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="Address2" DataSetColumn="Address2" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="PostCode" DataSetColumn="PostCode" />
              <Mapping SourceColumn="StateId" DataSetColumn="StateId" />
              <Mapping SourceColumn="CountryId" DataSetColumn="CountryId" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="UnitDescription" DataSetColumn="UnitDescription" />
              <Mapping SourceColumn="PlacementTypeName" DataSetColumn="PlacementTypeName" />
              <Mapping SourceColumn="RequiredHours" DataSetColumn="RequiredHours" />
              <Mapping SourceColumn="DateStart" DataSetColumn="DateStart" />
              <Mapping SourceColumn="DateEnd" DataSetColumn="DateEnd" />
              <Mapping SourceColumn="YearLevel" DataSetColumn="YearLevel" />
              <Mapping SourceColumn="SemesterId" DataSetColumn="SemesterId" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="DivisionName" DataSetColumn="DivisionName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="JobTitle" DataSetColumn="JobTitle" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BundooraLetters" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="BundooraLetters" msprop:Generator_DataSetName="BundooraLetters">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DataTable1" msprop:Generator_UserTableName="DataTable1" msprop:Generator_RowDeletedName="DataTable1RowDeleted" msprop:Generator_TableClassName="DataTable1DataTable" msprop:Generator_RowChangedName="DataTable1RowChanged" msprop:Generator_RowClassName="DataTable1Row" msprop:Generator_RowChangingName="DataTable1RowChanging" msprop:Generator_RowEvArgName="DataTable1RowChangeEvent" msprop:Generator_RowEvHandlerName="DataTable1RowChangeEventHandler" msprop:Generator_TablePropName="DataTable1" msprop:Generator_TableVarName="tableDataTable1" msprop:Generator_RowDeletingName="DataTable1RowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VenueName" msprop:Generator_UserColumnName="VenueName" msprop:Generator_ColumnPropNameInRow="VenueName" msprop:Generator_ColumnVarNameInTable="columnVenueName" msprop:Generator_ColumnPropNameInTable="VenueNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitCode" msprop:Generator_UserColumnName="UnitCode" msprop:Generator_ColumnPropNameInRow="UnitCode" msprop:Generator_ColumnVarNameInTable="columnUnitCode" msprop:Generator_ColumnPropNameInTable="UnitCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitName" msprop:Generator_UserColumnName="UnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address1" msprop:Generator_UserColumnName="Address1" msprop:Generator_ColumnPropNameInRow="Address1" msprop:Generator_ColumnVarNameInTable="columnAddress1" msprop:Generator_ColumnPropNameInTable="Address1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address2" msprop:Generator_UserColumnName="Address2" msprop:Generator_ColumnPropNameInRow="Address2" msprop:Generator_ColumnVarNameInTable="columnAddress2" msprop:Generator_ColumnPropNameInTable="Address2Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street" msprop:Generator_UserColumnName="Street" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_ColumnPropNameInTable="StreetColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostCode" msprop:Generator_UserColumnName="PostCode" msprop:Generator_ColumnPropNameInRow="PostCode" msprop:Generator_ColumnVarNameInTable="columnPostCode" msprop:Generator_ColumnPropNameInTable="PostCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StateId" msprop:Generator_UserColumnName="StateId" msprop:Generator_ColumnPropNameInRow="StateId" msprop:Generator_ColumnVarNameInTable="columnStateId" msprop:Generator_ColumnPropNameInTable="StateIdColumn" type="xs:int" />
              <xs:element name="CountryId" msprop:Generator_UserColumnName="CountryId" msprop:Generator_ColumnPropNameInRow="CountryId" msprop:Generator_ColumnVarNameInTable="columnCountryId" msprop:Generator_ColumnPropNameInTable="CountryIdColumn" type="xs:int" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitDescription" msprop:Generator_UserColumnName="UnitDescription" msprop:Generator_ColumnPropNameInRow="UnitDescription" msprop:Generator_ColumnVarNameInTable="columnUnitDescription" msprop:Generator_ColumnPropNameInTable="UnitDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PlacementTypeName" msprop:Generator_UserColumnName="PlacementTypeName" msprop:Generator_ColumnPropNameInRow="PlacementTypeName" msprop:Generator_ColumnVarNameInTable="columnPlacementTypeName" msprop:Generator_ColumnPropNameInTable="PlacementTypeNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequiredHours" msprop:Generator_UserColumnName="RequiredHours" msprop:Generator_ColumnPropNameInRow="RequiredHours" msprop:Generator_ColumnVarNameInTable="columnRequiredHours" msprop:Generator_ColumnPropNameInTable="RequiredHoursColumn" type="xs:int" />
              <xs:element name="DateStart" msprop:Generator_UserColumnName="DateStart" msprop:Generator_ColumnPropNameInRow="DateStart" msprop:Generator_ColumnVarNameInTable="columnDateStart" msprop:Generator_ColumnPropNameInTable="DateStartColumn" type="xs:dateTime" />
              <xs:element name="DateEnd" msprop:Generator_UserColumnName="DateEnd" msprop:Generator_ColumnPropNameInRow="DateEnd" msprop:Generator_ColumnVarNameInTable="columnDateEnd" msprop:Generator_ColumnPropNameInTable="DateEndColumn" type="xs:dateTime" />
              <xs:element name="YearLevel" msprop:Generator_UserColumnName="YearLevel" msprop:Generator_ColumnPropNameInRow="YearLevel" msprop:Generator_ColumnVarNameInTable="columnYearLevel" msprop:Generator_ColumnPropNameInTable="YearLevelColumn" type="xs:int" />
              <xs:element name="SemesterId" msprop:Generator_UserColumnName="SemesterId" msprop:Generator_ColumnPropNameInRow="SemesterId" msprop:Generator_ColumnVarNameInTable="columnSemesterId" msprop:Generator_ColumnPropNameInTable="SemesterIdColumn" type="xs:int" />
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" />
              <xs:element name="DivisionName" msprop:Generator_UserColumnName="DivisionName" msprop:Generator_ColumnPropNameInRow="DivisionName" msprop:Generator_ColumnVarNameInTable="columnDivisionName" msprop:Generator_ColumnPropNameInTable="DivisionNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JobTitle" msprop:Generator_UserColumnName="JobTitle" msprop:Generator_ColumnPropNameInRow="JobTitle" msprop:Generator_ColumnVarNameInTable="columnJobTitle" msprop:Generator_ColumnPropNameInTable="JobTitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>